IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spTGovdep_Retrieve')
	BEGIN
		PRINT 'Dropping Procedure spTGovdep_Retrieve'
		DROP  Procedure  spTGovdep_Retrieve
	END

GO

PRINT 'Creating Procedure spTGovdep_Retrieve'
GO
CREATE Procedure dbo.spTGovdep_Retrieve
	(
	  @TGovdep_ID  bigint
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 9/13/2007   Initial version created
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Create the required new record
	SELECT  *
	FROM    TGovdep
	WHERE   TGovdep.TGovdep_ID = @TGovdep_ID

	-- Return to calling method
	RETURN 

GO
